<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
include_once("conn.php");
$deleted=$_REQUEST['deleted'];
$dept=$_REQUEST['dept'];
$major=$_REQUEST['major'];

if ($deleted==0){
	$sql = "SELECT * FROM dept WHERE `name` = '$dept'";
	$result=mysql_query($sql);
	while($row = mysql_fetch_row($result)){
		$majorName=$row[2];
		$sql2="DELETE FROM course WHERE `major` = '$majorName'";
		$result2=mysql_query($sql2);
	}

	$sql="DELETE FROM dept WHERE `name` = '$dept'";
	$result=mysql_query($sql);

	$sql="DELETE FROM student WHERE `dept` = '$dept'";
	$result=mysql_query($sql);

	$sql="DELETE FROM teacher WHERE `dept` = '$dept'";
	$result=mysql_query($sql);
}
else{
	$sql="DELETE FROM course WHERE `major` = '$major'";
	$result=mysql_query($sql);

	$sql="DELETE FROM student WHERE `major` = '$major'";
	$result=mysql_query($sql);
}
echo $result?"删除成功":"删除失败";
mysql_close($conn);
?>
</body>
</html>